package com.itxiuyixiu.entity.mapper;

import org.apache.ibatis.annotations.Select;

/**
 * @author 黄磊
 * @date 2020/6/2
 */
public interface TestMapper {
    /**
     * 获取用户表当前的自增主键的值
     *
     * @return 自增主键的值
     */
    @Select("SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'volunteer' AND   TABLE_NAME   = 'User'")
    int getNowUserId();

    /**
     * 获取管理员表当前的自增主键的值
     *
     * @return 自增主键的值
     */
    @Select("SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'volunteer' AND   TABLE_NAME   = 'Admin'")
    int getNowAdminId();
}
